3 visuals for webpage
This code will help produce the three visuals that are going to be a
part of each equity tracker indicator webpage: regional map (tract
level) of most recent data, chart of the most recent data, chart of
trends over time.
If the indicator is available through a tract-level data
set. Getting the data to a workable version may require some
data transformation. To explore, clean, transform, and generate a final
data set, please use the data-gen-tract-template. This script
will generate an .rda for the map and an .rda for the charts. These data
sets will be loaded in before the data visualization code.
Indicator Explanation
Measuring the proportion of sidewalks along an arterial segment gives
us an idea of the completeness of pedestrian infrastructure on major
travel corridors in the region. Differences between groups of people can
highlight differing access to safe infrastructure. For this indicator,
we are measuring sidewalk completeness as the percent of partial or
complete sidewalks along the total length of arterial segments within a
given census tract.
1. Map of most recent data
To map data in this form, there should be a value corresponding to
each census tract. Depending on the year or source of the data, this
could be about 700 rows for data at the 2010 census tract resolution, or
about 900 rows for data at the 2020 census tract resolution.
Create Visual
Source(s): Puget Sound Regional Council, Regional Bicycle and
Pedestrian Facilities, 2022; U.S. Census Bureau, Geography Division 2020
TIGER/Line Shapefiles
Data call outs
- 49%: The share of arterial road segments in the region with partial
or complete sidewalks
- 31%: The share of tracts where all arterial segments have partial or
complete sidewalks
- 5%: The share of tracts where all arterial segments have no
sidewalks
Insights & Analysis
- King County has the highest percent of sidewalk completeness (73%),
followed by Snohomish (51%), Pierce (41%), and Kitsap (26%)
- Half of all census tracts in the region have a sidewalk completeness
share of 88% or greater
- Each county in the region has tracts with 100% sidewalk completeness
and tracts with 0% sidewalk completeness
2. Facet of most recent data
Create Visual
Sidewalk Completeness by Community
Percent of arterial road segments with partial or complete sidewalks
Data call outs
- 83%: The share of sidewalk completeness for census tracts in the
region with the highest concentration of limited English proficient
households, compared to 38% in census tracts with the lowest
concentration of limited English proficient households
- 5%: The lowest share of sidewalk completeness across categories,
found in Kitsap County tracts with the lowest proportion of limited
English proficient households
- 28%: The share of sidewalk completeness for tracts in Pierce County
with the highest concentration of people with disabilities
Insights & Analysis
- Census tracts in the region with the highest concentration of people
of color have more than three times the proportion of sidewalk
completeness along arterials than tracts with the lowest concentration
of people of color (80% vs. 25%).
- The highest proportion of sidewalk completeness (96%) is found in
King County tracts with the lowest concentration of households with
youth. Tracts in King County with the highest concentration of
households with youth have a share of only 59%.
- For the region as a whole, tracts with the highest concentration of
people of color, low income households, and limited English proficient
households have higher proportions of sidewalk completeness than tracts
with the lowest concentration of those groups. For tracts with the
highest concentration of people with disabilities and households with
older adults, the opposite is true.